{% for join_algorithm in ['default', 'grace_hash', 'full_sorting_merge'] -%}
join_algorithm = {{ join_algorithm }}, join_use_nulls = 0, t1 JOIN t2
--
\N	0	2	2
\N	0	6	6
\N	0	10	10
\N	0	14	14
\N	0	18	18
1	1	1	1
\N	2	\N	4
\N	2	\N	8
\N	2	\N	12
\N	2	\N	16
\N	2	\N	20
3	3	3	3
\N	4	\N	4
\N	4	\N	8
\N	4	\N	12
\N	4	\N	16
\N	4	\N	20
5	5	5	5
\N	6	\N	4
\N	6	\N	8
\N	6	\N	12
\N	6	\N	16
\N	6	\N	20
7	7	7	7
\N	8	\N	4
\N	8	\N	8
\N	8	\N	12
\N	8	\N	16
\N	8	\N	20
9	9	9	9
\N	10	\N	4
\N	10	\N	8
\N	10	\N	12
\N	10	\N	16
\N	10	\N	20
11	11	11	11
\N	12	\N	4
\N	12	\N	8
\N	12	\N	12
\N	12	\N	16
\N	12	\N	20
13	13	13	13
\N	14	\N	4
\N	14	\N	8
\N	14	\N	12
\N	14	\N	16
\N	14	\N	20
15	15	15	15
\N	16	\N	4
\N	16	\N	8
\N	16	\N	12
\N	16	\N	16
\N	16	\N	20
17	17	17	17
\N	18	\N	4
\N	18	\N	8
\N	18	\N	12
\N	18	\N	16
\N	18	\N	20
19	19	19	19
\N	20	\N	4
\N	20	\N	8
\N	20	\N	12
\N	20	\N	16
\N	20	\N	20
--
\N	\N	0	2	2	2
\N	\N	0	3	\N	3
\N	\N	0	6	\N	6
\N	\N	0	9	\N	9
\N	\N	0	10	10	10
\N	\N	0	14	14	14
\N	\N	0	15	\N	15
\N	\N	0	18	\N	18
1	1	1	1	1	1
\N	2	2	\N	\N	0
3	3	3	\N	\N	0
\N	4	4	\N	4	4
5	5	5	5	5	5
\N	\N	6	\N	\N	12
7	7	7	7	7	7
\N	8	8	\N	8	8
9	9	9	\N	\N	0
\N	10	10	\N	\N	0
11	11	11	11	11	11
\N	\N	12	\N	\N	12
13	13	13	13	13	13
\N	14	14	\N	\N	0
15	15	15	\N	\N	0
\N	16	16	\N	16	16
17	17	17	17	17	17
\N	\N	18	\N	\N	12
19	19	19	19	19	19
\N	20	20	\N	20	20
--
\N	\N	0	2	2	2
\N	\N	0	3	\N	3
\N	\N	0	\N	4	4
\N	\N	0	6	\N	6
\N	\N	0	\N	8	8
\N	\N	0	9	\N	9
\N	\N	0	10	10	10
\N	\N	0	\N	\N	12
\N	\N	0	14	14	14
\N	\N	0	15	\N	15
\N	\N	0	\N	16	16
\N	\N	0	18	\N	18
\N	\N	0	\N	20	20
1	1	1	1	1	1
\N	2	2	\N	\N	0
3	3	3	\N	\N	0
\N	4	4	\N	\N	0
5	5	5	5	5	5
\N	\N	6	\N	\N	0
7	7	7	7	7	7
\N	8	8	\N	\N	0
9	9	9	\N	\N	0
\N	10	10	\N	\N	0
11	11	11	11	11	11
\N	\N	12	\N	\N	0
13	13	13	13	13	13
\N	14	14	\N	\N	0
15	15	15	\N	\N	0
\N	16	16	\N	\N	0
17	17	17	17	17	17
\N	\N	18	\N	\N	0
19	19	19	19	19	19
\N	20	20	\N	\N	0
--
\N	\N	0	2	2	2
\N	\N	0	3	\N	3
\N	\N	0	6	\N	6
\N	\N	0	9	\N	9
\N	\N	0	10	10	10
\N	\N	0	\N	\N	12
\N	\N	0	14	14	14
\N	\N	0	15	\N	15
\N	\N	0	18	\N	18
1	1	1	1	1	1
\N	2	2	\N	\N	0
3	3	3	\N	\N	0
\N	4	4	\N	4	4
5	5	5	5	5	5
\N	\N	6	\N	\N	0
7	7	7	7	7	7
\N	8	8	\N	8	8
9	9	9	\N	\N	0
\N	10	10	\N	\N	0
11	11	11	11	11	11
\N	\N	12	\N	\N	0
13	13	13	13	13	13
\N	14	14	\N	\N	0
15	15	15	\N	\N	0
\N	16	16	\N	16	16
17	17	17	17	17	17
\N	\N	18	\N	\N	0
19	19	19	19	19	19
\N	20	20	\N	20	20
{% endfor -%}
join_algorithm = default, join_use_nulls = 1, t1 JOIN t2
--
\N	\N	2	2
\N	\N	6	6
\N	\N	10	10
\N	\N	14	14
\N	\N	18	18
1	1	1	1
\N	2	\N	4
\N	2	\N	8
\N	2	\N	12
\N	2	\N	16
\N	2	\N	20
3	3	3	3
\N	4	\N	4
\N	4	\N	8
\N	4	\N	12
\N	4	\N	16
\N	4	\N	20
5	5	5	5
\N	6	\N	4
\N	6	\N	8
\N	6	\N	12
\N	6	\N	16
\N	6	\N	20
7	7	7	7
\N	8	\N	4
\N	8	\N	8
\N	8	\N	12
\N	8	\N	16
\N	8	\N	20
9	9	9	9
\N	10	\N	4
\N	10	\N	8
\N	10	\N	12
\N	10	\N	16
\N	10	\N	20
11	11	11	11
\N	12	\N	4
\N	12	\N	8
\N	12	\N	12
\N	12	\N	16
\N	12	\N	20
13	13	13	13
\N	14	\N	4
\N	14	\N	8
\N	14	\N	12
\N	14	\N	16
\N	14	\N	20
15	15	15	15
\N	16	\N	4
\N	16	\N	8
\N	16	\N	12
\N	16	\N	16
\N	16	\N	20
17	17	17	17
\N	18	\N	4
\N	18	\N	8
\N	18	\N	12
\N	18	\N	16
\N	18	\N	20
19	19	19	19
\N	20	\N	4
\N	20	\N	8
\N	20	\N	12
\N	20	\N	16
\N	20	\N	20
--
\N	\N	\N	2	2	2
\N	\N	\N	3	\N	3
\N	\N	\N	6	\N	6
\N	\N	\N	9	\N	9
\N	\N	\N	10	10	10
\N	\N	\N	14	14	14
\N	\N	\N	15	\N	15
\N	\N	\N	18	\N	18
1	1	1	1	1	1
\N	2	2	\N	\N	\N
3	3	3	\N	\N	\N
\N	4	4	\N	4	4
5	5	5	5	5	5
\N	\N	6	\N	\N	12
7	7	7	7	7	7
\N	8	8	\N	8	8
9	9	9	\N	\N	\N
\N	10	10	\N	\N	\N
11	11	11	11	11	11
\N	\N	12	\N	\N	12
13	13	13	13	13	13
\N	14	14	\N	\N	\N
15	15	15	\N	\N	\N
\N	16	16	\N	16	16
17	17	17	17	17	17
\N	\N	18	\N	\N	12
19	19	19	19	19	19
\N	20	20	\N	20	20
--
\N	\N	\N	2	2	2
\N	\N	\N	3	\N	3
\N	\N	\N	\N	4	4
\N	\N	\N	6	\N	6
\N	\N	\N	\N	8	8
\N	\N	\N	9	\N	9
\N	\N	\N	10	10	10
\N	\N	\N	\N	\N	12
\N	\N	\N	14	14	14
\N	\N	\N	15	\N	15
\N	\N	\N	\N	16	16
\N	\N	\N	18	\N	18
\N	\N	\N	\N	20	20
1	1	1	1	1	1
\N	2	2	\N	\N	\N
3	3	3	\N	\N	\N
\N	4	4	\N	\N	\N
5	5	5	5	5	5
\N	\N	6	\N	\N	\N
7	7	7	7	7	7
\N	8	8	\N	\N	\N
9	9	9	\N	\N	\N
\N	10	10	\N	\N	\N
11	11	11	11	11	11
\N	\N	12	\N	\N	\N
13	13	13	13	13	13
\N	14	14	\N	\N	\N
15	15	15	\N	\N	\N
\N	16	16	\N	\N	\N
17	17	17	17	17	17
\N	\N	18	\N	\N	\N
19	19	19	19	19	19
\N	20	20	\N	\N	\N
--
\N	\N	\N	2	2	2
\N	\N	\N	3	\N	3
\N	\N	\N	6	\N	6
\N	\N	\N	9	\N	9
\N	\N	\N	10	10	10
\N	\N	\N	\N	\N	12
\N	\N	\N	14	14	14
\N	\N	\N	15	\N	15
\N	\N	\N	18	\N	18
1	1	1	1	1	1
\N	2	2	\N	\N	\N
3	3	3	\N	\N	\N
\N	4	4	\N	4	4
5	5	5	5	5	5
\N	\N	6	\N	\N	\N
7	7	7	7	7	7
\N	8	8	\N	8	8
9	9	9	\N	\N	\N
\N	10	10	\N	\N	\N
11	11	11	11	11	11
\N	\N	12	\N	\N	\N
13	13	13	13	13	13
\N	14	14	\N	\N	\N
15	15	15	\N	\N	\N
\N	16	16	\N	16	16
17	17	17	17	17	17
\N	\N	18	\N	\N	\N
19	19	19	19	19	19
\N	20	20	\N	20	20
join_algorithm = default, join_use_nulls = 0, t1 JOIN t3
--
\N	0	2	2
\N	0	6	6
\N	0	10	10
\N	0	14	14
\N	0	18	18
1	1	1	1
\N	2	\N	4
\N	2	\N	8
\N	2	\N	12
\N	2	\N	16
\N	2	\N	20
3	3	3	3
\N	4	\N	4
\N	4	\N	8
\N	4	\N	12
\N	4	\N	16
\N	4	\N	20
5	5	5	5
\N	6	\N	4
\N	6	\N	8
\N	6	\N	12
\N	6	\N	16
\N	6	\N	20
7	7	7	7
\N	8	\N	4
\N	8	\N	8
\N	8	\N	12
\N	8	\N	16
\N	8	\N	20
9	9	9	9
\N	10	\N	4
\N	10	\N	8
\N	10	\N	12
\N	10	\N	16
\N	10	\N	20
11	11	11	11
\N	12	\N	4
\N	12	\N	8
\N	12	\N	12
\N	12	\N	16
\N	12	\N	20
13	13	13	13
\N	14	\N	4
\N	14	\N	8
\N	14	\N	12
\N	14	\N	16
\N	14	\N	20
15	15	15	15
\N	16	\N	4
\N	16	\N	8
\N	16	\N	12
\N	16	\N	16
\N	16	\N	20
17	17	17	17
\N	18	\N	4
\N	18	\N	8
\N	18	\N	12
\N	18	\N	16
\N	18	\N	20
19	19	19	19
\N	20	\N	4
\N	20	\N	8
\N	20	\N	12
\N	20	\N	16
\N	20	\N	20
--
\N	\N	0	2	2	2
\N	\N	0	3	0	3
\N	\N	0	6	0	6
\N	\N	0	9	0	9
\N	\N	0	10	10	10
\N	\N	0	\N	0	12
\N	\N	0	14	14	14
\N	\N	0	15	0	15
\N	\N	0	18	0	18
1	1	1	1	1	1
\N	2	2	\N	0	0
3	3	3	\N	0	0
\N	4	4	\N	4	4
5	5	5	5	5	5
\N	\N	6	\N	0	0
7	7	7	7	7	7
\N	8	8	\N	8	8
9	9	9	\N	0	0
\N	10	10	\N	0	0
11	11	11	11	11	11
\N	\N	12	\N	0	0
13	13	13	13	13	13
\N	14	14	\N	0	0
15	15	15	\N	0	0
\N	16	16	\N	16	16
17	17	17	17	17	17
\N	\N	18	\N	0	0
19	19	19	19	19	19
\N	20	20	\N	20	20
--
\N	\N	0	2	2	2
\N	\N	0	3	0	3
\N	\N	0	\N	4	4
\N	\N	0	6	0	6
\N	\N	0	\N	8	8
\N	\N	0	9	0	9
\N	\N	0	10	10	10
\N	\N	0	\N	0	12
\N	\N	0	14	14	14
\N	\N	0	15	0	15
\N	\N	0	\N	16	16
\N	\N	0	18	0	18
\N	\N	0	\N	20	20
1	1	1	1	1	1
\N	2	2	\N	0	0
3	3	3	\N	0	0
\N	4	4	\N	0	0
5	5	5	5	5	5
\N	\N	6	\N	0	0
7	7	7	7	7	7
\N	8	8	\N	0	0
9	9	9	\N	0	0
\N	10	10	\N	0	0
11	11	11	11	11	11
\N	\N	12	\N	0	0
13	13	13	13	13	13
\N	14	14	\N	0	0
15	15	15	\N	0	0
\N	16	16	\N	0	0
17	17	17	17	17	17
\N	\N	18	\N	0	0
19	19	19	19	19	19
\N	20	20	\N	0	0
--
\N	\N	0	2	2	2
\N	\N	0	3	0	3
\N	\N	0	6	0	6
\N	\N	0	9	0	9
\N	\N	0	10	10	10
\N	\N	0	\N	0	12
\N	\N	0	14	14	14
\N	\N	0	15	0	15
\N	\N	0	18	0	18
1	1	1	1	1	1
\N	2	2	\N	0	0
3	3	3	\N	0	0
\N	4	4	\N	4	4
5	5	5	5	5	5
\N	\N	6	\N	0	0
7	7	7	7	7	7
\N	8	8	\N	8	8
9	9	9	\N	0	0
\N	10	10	\N	0	0
11	11	11	11	11	11
\N	\N	12	\N	0	0
13	13	13	13	13	13
\N	14	14	\N	0	0
15	15	15	\N	0	0
\N	16	16	\N	16	16
17	17	17	17	17	17
\N	\N	18	\N	0	0
19	19	19	19	19	19
\N	20	20	\N	20	20
join_algorithm = default, join_use_nulls = 0, t1 JOIN t4
--
\N	0	2	2
\N	0	0	4
\N	0	6	6
\N	0	0	8
\N	0	10	10
\N	0	0	12
\N	0	14	14
\N	0	0	16
\N	0	18	18
\N	0	0	20
1	1	1	1
\N	2	0	0
3	3	3	3
\N	4	0	0
5	5	5	5
\N	6	0	0
7	7	7	7
\N	8	0	0
9	9	9	9
\N	10	0	0
11	11	11	11
\N	12	0	0
13	13	13	13
\N	14	0	0
15	15	15	15
\N	16	0	0
17	17	17	17
\N	18	0	0
19	19	19	19
\N	20	0	0
--
\N	\N	0	2	2	2
\N	\N	0	3	0	3
\N	\N	0	0	4	4
\N	\N	0	6	0	6
\N	\N	0	0	8	8
\N	\N	0	9	0	9
\N	\N	0	10	10	10
\N	\N	0	0	0	12
\N	\N	0	14	14	14
\N	\N	0	15	0	15
\N	\N	0	0	16	16
\N	\N	0	18	0	18
\N	\N	0	0	20	20
1	1	1	1	1	1
\N	2	2	0	0	0
3	3	3	0	0	0
\N	4	4	0	0	0
5	5	5	5	5	5
\N	\N	6	0	0	0
7	7	7	7	7	7
\N	8	8	0	0	0
9	9	9	0	0	0
\N	10	10	0	0	0
11	11	11	11	11	11
\N	\N	12	0	0	0
13	13	13	13	13	13
\N	14	14	0	0	0
15	15	15	0	0	0
\N	16	16	0	0	0
17	17	17	17	17	17
\N	\N	18	0	0	0
19	19	19	19	19	19
\N	20	20	0	0	0
--
\N	\N	0	2	2	2
\N	\N	0	3	0	3
\N	\N	0	0	4	4
\N	\N	0	6	0	6
\N	\N	0	0	8	8
\N	\N	0	9	0	9
\N	\N	0	10	10	10
\N	\N	0	0	0	12
\N	\N	0	14	14	14
\N	\N	0	15	0	15
\N	\N	0	0	16	16
\N	\N	0	18	0	18
\N	\N	0	0	20	20
1	1	1	1	1	1
\N	2	2	0	0	0
3	3	3	0	0	0
\N	4	4	0	0	0
5	5	5	5	5	5
\N	\N	6	0	0	0
7	7	7	7	7	7
\N	8	8	0	0	0
9	9	9	0	0	0
\N	10	10	0	0	0
11	11	11	11	11	11
\N	\N	12	0	0	0
13	13	13	13	13	13
\N	14	14	0	0	0
15	15	15	0	0	0
\N	16	16	0	0	0
17	17	17	17	17	17
\N	\N	18	0	0	0
19	19	19	19	19	19
\N	20	20	0	0	0
--
\N	\N	0	2	2	2
\N	\N	0	3	0	3
\N	\N	0	0	4	4
\N	\N	0	6	0	6
\N	\N	0	0	8	8
\N	\N	0	9	0	9
\N	\N	0	10	10	10
\N	\N	0	0	0	12
\N	\N	0	14	14	14
\N	\N	0	15	0	15
\N	\N	0	0	16	16
\N	\N	0	18	0	18
\N	\N	0	0	20	20
1	1	1	1	1	1
\N	2	2	0	0	0
3	3	3	0	0	0
\N	4	4	0	0	0
5	5	5	5	5	5
\N	\N	6	0	0	0
7	7	7	7	7	7
\N	8	8	0	0	0
9	9	9	0	0	0
\N	10	10	0	0	0
11	11	11	11	11	11
\N	\N	12	0	0	0
13	13	13	13	13	13
\N	14	14	0	0	0
15	15	15	0	0	0
\N	16	16	0	0	0
17	17	17	17	17	17
\N	\N	18	0	0	0
19	19	19	19	19	19
\N	20	20	0	0	0
--
\N	0	2	2
\N	0	\N	4
\N	0	6	6
\N	0	\N	8
\N	0	10	10
\N	0	\N	12
\N	0	14	14
\N	0	\N	16
\N	0	18	18
\N	0	\N	20
1	1	1	1
\N	2	\N	0
3	3	3	3
\N	4	\N	0
5	5	5	5
\N	6	\N	0
7	7	7	7
\N	8	\N	0
9	9	9	9
\N	10	\N	0
11	11	11	11
\N	12	\N	0
13	13	13	13
\N	14	\N	0
15	15	15	15
\N	16	\N	0
17	17	17	17
\N	18	\N	0
19	19	19	19
\N	20	\N	0
--
\N	0	2	2
\N	0	\N	4
\N	0	6	6
\N	0	\N	8
\N	0	10	10
\N	0	\N	12
\N	0	14	14
\N	0	\N	16
\N	0	18	18
\N	0	\N	20
1	1	1	1
\N	2	\N	0
3	3	3	3
\N	4	\N	0
5	5	5	5
\N	6	\N	0
7	7	7	7
\N	8	\N	0
9	9	9	9
\N	10	\N	0
11	11	11	11
\N	12	\N	0
13	13	13	13
\N	14	\N	0
15	15	15	15
\N	16	\N	0
17	17	17	17
\N	18	\N	0
19	19	19	19
\N	20	\N	0
--
1	42	420	1	1	43	430	1
\N	42	420	2	\N	43	430	4
\N	42	420	2	\N	43	430	8
\N	42	420	2	\N	43	430	12
\N	42	420	2	\N	43	430	16
\N	42	420	2	\N	43	430	20
3	42	420	3	3	43	430	3
\N	42	420	4	\N	43	430	4
\N	42	420	4	\N	43	430	8
\N	42	420	4	\N	43	430	12
--
1	42	420	1	1	43	430	1
\N	42	420	2	\N	43	430	4
\N	42	420	2	\N	43	430	8
\N	42	420	2	\N	43	430	12
\N	42	420	2	\N	43	430	16
\N	42	420	2	\N	43	430	20
3	42	420	3	3	43	430	3
\N	42	420	4	\N	43	430	4
\N	42	420	4	\N	43	430	8
\N	42	420	4	\N	43	430	12
--
1
0
1
0
1
1
1
0
1
0
--
1
0
1
0
1
1
1
0
1
0
--
1
0
1
0
1
1
1
0
1
0
--
